/**
 * 
 */
package com.java.test.mapper;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import com.java.test.messagecenter.dto.TerminalInfo;
import com.java.test.system.feesettings.entity.FundsTypeEntity;
import com.java.test.system.registrationtemplate.entity.AreaEntity;
import com.java.test.user.dto.MemberSliceInfo;

/**
 * @author Administrator
 *
 */
@Component
public class AreaMapper {

	@Autowired
	private JdbcTemplate jdbcTemplate;

	public List<AreaEntity> selectAreaNamebyId(String ids) {

		String sql = "select * from sys_area where id in (" + ids + ")";

		List<AreaEntity> list = jdbcTemplate.query(sql, new AreaEntity());

		return list;

	}
	
	
	public List<FundsTypeEntity> selectfoundsType(String ids){
		
		String sql = "select * from sys_funds_type where id in (" + ids + ")";

		List<FundsTypeEntity> list = jdbcTemplate.query(sql, new FundsTypeEntity());

		return list;
	}
	
	
	public List<MemberSliceInfo> selectMemberSliceInfo(String ids){
		
		String sql = "select * from member_member_slice where id in (" + ids + ")";

		List<MemberSliceInfo> list = jdbcTemplate.query(sql, new MemberSliceInfo());

		return list;
	}
	
	
	
	public List<TerminalInfo> selectterminalbyIdInfo(String ids) {

		String sql = "select * from terminal_terminalinfo where id in (" + ids + ")";

		List<TerminalInfo> obj = jdbcTemplate.query(sql, new TerminalInfo());

		return obj;
	}


}
